Analyzing and Visualizing Ariel Bombing Damage During WW2

By Justin McKinney and Justin Ashbaugh

Step 1: The Dataset

The dataset we choose was a subset of the "Theater History of Operations", which is a dataset that tracks every ariel bombing mission recoded from WW1 to Vietnam. This particular data set contains records of allied bombing missions over the course of WW2 including whats planes, what types of bombs, their targets, and many other things. It is in a CSV format and in a few seprate files that contain tables of information about the various data.

Now that we have loaded the data lets do some basic analysis! Lets see how many tons of bombs the allies dropped over the corse of the war. We can do this easily by specifying the column containing the total tons of weaponry dropped and calling sum on that column.

That is a pretty isane amount of weaponry dropped over the corse of WW2. Now lets try to recreate that graph on the website we got the data from that showed which countries had the most tons of weaponry dropped on them.

Wow! That is a lot of bombs dropped on Germany and occupied France. Now lets now see who was dropping those bombs. We can do a similar strategey as the last graph except this time we will group by the country flying the mission instead of the target country.

Now lets find which planes did most of the bomb dropping.

Now lets bring in folium to do some visualizing of what areas were bombed the most. Folium will let us create an interactive heatmap in order to see what areas were most bombed by the allies throughout the war. For viewer convience we will lable the capital cities of the main Axis powers.